package com.ecoolex.union.pay.retailer.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class UnionPayPopularMerchantProductExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public UnionPayPopularMerchantProductExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public UnionPayPopularMerchantProductExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public UnionPayPopularMerchantProductExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        UnionPayPopularMerchantProductExample example = new UnionPayPopularMerchantProductExample();
        return example.createCriteria();
    }

    public UnionPayPopularMerchantProductExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public UnionPayPopularMerchantProductExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public UnionPayPopularMerchantProductExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public UnionPayPopularMerchantProductExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public UnionPayPopularMerchantProductExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("unionpaypopularmerchantproduct.Id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.Id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.Id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Id = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.Id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Id <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.Id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Id > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.Id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Id >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.Id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Id < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.Id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Id <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("unionpaypopularmerchantproduct.Id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("unionpaypopularmerchantproduct.Id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("unionpaypopularmerchantproduct.Id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("unionpaypopularmerchantproduct.Id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNull() {
            addCriterion("unionpaypopularmerchantproduct.ProductId is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.ProductId is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.ProductId =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.ProductId <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.ProductId >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.ProductId >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.ProductId <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.ProductId <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<Integer> values) {
            addCriterion("unionpaypopularmerchantproduct.ProductId in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<Integer> values) {
            addCriterion("unionpaypopularmerchantproduct.ProductId not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(Integer value1, Integer value2) {
            addCriterion("unionpaypopularmerchantproduct.ProductId between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("unionpaypopularmerchantproduct.ProductId not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNull() {
            addCriterion("unionpaypopularmerchantproduct.MerchantId is null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.MerchantId is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId =", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.MerchantId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId <>", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.MerchantId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId >", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.MerchantId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId >=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.MerchantId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId <", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.MerchantId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId <=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.MerchantId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMerchantIdLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId like", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId not like", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId not in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.MerchantId not between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andProductNameIsNull() {
            addCriterion("unionpaypopularmerchantproduct.ProductName is null");
            return (Criteria) this;
        }

        public Criteria andProductNameIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.ProductName is not null");
            return (Criteria) this;
        }

        public Criteria andProductNameEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductName =", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductName = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductNameNotEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductName <>", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductName <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductName >", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductName > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductName >=", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductName >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductNameLessThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductName <", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductName < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductNameLessThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductName <=", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductName <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductNameLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductName like", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductName not like", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.ProductName in", values, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.ProductName not in", values, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.ProductName between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.ProductName not between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria andProductImageIsNull() {
            addCriterion("unionpaypopularmerchantproduct.ProductImage is null");
            return (Criteria) this;
        }

        public Criteria andProductImageIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.ProductImage is not null");
            return (Criteria) this;
        }

        public Criteria andProductImageEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage =", value, "productImage");
            return (Criteria) this;
        }

        public Criteria andProductImageEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductImage = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductImageNotEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage <>", value, "productImage");
            return (Criteria) this;
        }

        public Criteria andProductImageNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductImage <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductImageGreaterThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage >", value, "productImage");
            return (Criteria) this;
        }

        public Criteria andProductImageGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductImage > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductImageGreaterThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage >=", value, "productImage");
            return (Criteria) this;
        }

        public Criteria andProductImageGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductImage >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductImageLessThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage <", value, "productImage");
            return (Criteria) this;
        }

        public Criteria andProductImageLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductImage < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductImageLessThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage <=", value, "productImage");
            return (Criteria) this;
        }

        public Criteria andProductImageLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductImage <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductImageLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage like", value, "productImage");
            return (Criteria) this;
        }

        public Criteria andProductImageNotLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage not like", value, "productImage");
            return (Criteria) this;
        }

        public Criteria andProductImageIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage in", values, "productImage");
            return (Criteria) this;
        }

        public Criteria andProductImageNotIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage not in", values, "productImage");
            return (Criteria) this;
        }

        public Criteria andProductImageBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage between", value1, value2, "productImage");
            return (Criteria) this;
        }

        public Criteria andProductImageNotBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.ProductImage not between", value1, value2, "productImage");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeIsNull() {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode =", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CurrencyCode = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeNotEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode <>", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CurrencyCode <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeGreaterThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode >", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CurrencyCode > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeGreaterThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode >=", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CurrencyCode >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeLessThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode <", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CurrencyCode < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeLessThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode <=", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CurrencyCode <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode like", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeNotLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode not like", value, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode in", values, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeNotIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode not in", values, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode between", value1, value2, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCurrencyCodeNotBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.CurrencyCode not between", value1, value2, "currencyCode");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNull() {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice =", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice <>", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice >", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice >=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThan(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice <", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice <=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceIn(List<BigDecimal> values) {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice not in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unionpaypopularmerchantproduct.CounterPrice not between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceIsNull() {
            addCriterion("unionpaypopularmerchantproduct.CostPrice is null");
            return (Criteria) this;
        }

        public Criteria andCostPriceIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.CostPrice is not null");
            return (Criteria) this;
        }

        public Criteria andCostPriceEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CostPrice =", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CostPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCostPriceNotEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CostPrice <>", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CostPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCostPriceGreaterThan(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CostPrice >", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CostPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCostPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CostPrice >=", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CostPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCostPriceLessThan(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CostPrice <", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CostPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCostPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.CostPrice <=", value, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CostPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCostPriceIn(List<BigDecimal> values) {
            addCriterion("unionpaypopularmerchantproduct.CostPrice in", values, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceNotIn(List<BigDecimal> values) {
            addCriterion("unionpaypopularmerchantproduct.CostPrice not in", values, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unionpaypopularmerchantproduct.CostPrice between", value1, value2, "costPrice");
            return (Criteria) this;
        }

        public Criteria andCostPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unionpaypopularmerchantproduct.CostPrice not between", value1, value2, "costPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNull() {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice =", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice <>", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThan(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice >", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice >=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThan(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice <", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice <=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceIn(List<BigDecimal> values) {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotIn(List<BigDecimal> values) {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice not in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unionpaypopularmerchantproduct.RetailPrice not between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbIsNull() {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb is null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb is not null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb =", value, "retailPriceRmb");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPriceRmb = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbNotEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb <>", value, "retailPriceRmb");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPriceRmb <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbGreaterThan(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb >", value, "retailPriceRmb");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPriceRmb > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb >=", value, "retailPriceRmb");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPriceRmb >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbLessThan(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb <", value, "retailPriceRmb");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPriceRmb < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbLessThanOrEqualTo(BigDecimal value) {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb <=", value, "retailPriceRmb");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.RetailPriceRmb <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbIn(List<BigDecimal> values) {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb in", values, "retailPriceRmb");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbNotIn(List<BigDecimal> values) {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb not in", values, "retailPriceRmb");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb between", value1, value2, "retailPriceRmb");
            return (Criteria) this;
        }

        public Criteria andRetailPriceRmbNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("unionpaypopularmerchantproduct.RetailPriceRmb not between", value1, value2, "retailPriceRmb");
            return (Criteria) this;
        }

        public Criteria andSpecSortingIsNull() {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting is null");
            return (Criteria) this;
        }

        public Criteria andSpecSortingIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting is not null");
            return (Criteria) this;
        }

        public Criteria andSpecSortingEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting =", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.SpecSorting = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingNotEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting <>", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.SpecSorting <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingGreaterThan(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting >", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.SpecSorting > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingGreaterThanOrEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting >=", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.SpecSorting >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingLessThan(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting <", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.SpecSorting < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingLessThanOrEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting <=", value, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.SpecSorting <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecSortingIn(List<Integer> values) {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting in", values, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingNotIn(List<Integer> values) {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting not in", values, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingBetween(Integer value1, Integer value2) {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting between", value1, value2, "specSorting");
            return (Criteria) this;
        }

        public Criteria andSpecSortingNotBetween(Integer value1, Integer value2) {
            addCriterion("unionpaypopularmerchantproduct.SpecSorting not between", value1, value2, "specSorting");
            return (Criteria) this;
        }

        public Criteria andProductUrlIsNull() {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl is null");
            return (Criteria) this;
        }

        public Criteria andProductUrlIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl is not null");
            return (Criteria) this;
        }

        public Criteria andProductUrlEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl =", value, "productUrl");
            return (Criteria) this;
        }

        public Criteria andProductUrlEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductUrl = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductUrlNotEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl <>", value, "productUrl");
            return (Criteria) this;
        }

        public Criteria andProductUrlNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductUrl <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductUrlGreaterThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl >", value, "productUrl");
            return (Criteria) this;
        }

        public Criteria andProductUrlGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductUrl > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductUrlGreaterThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl >=", value, "productUrl");
            return (Criteria) this;
        }

        public Criteria andProductUrlGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductUrl >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductUrlLessThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl <", value, "productUrl");
            return (Criteria) this;
        }

        public Criteria andProductUrlLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductUrl < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductUrlLessThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl <=", value, "productUrl");
            return (Criteria) this;
        }

        public Criteria andProductUrlLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.ProductUrl <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProductUrlLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl like", value, "productUrl");
            return (Criteria) this;
        }

        public Criteria andProductUrlNotLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl not like", value, "productUrl");
            return (Criteria) this;
        }

        public Criteria andProductUrlIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl in", values, "productUrl");
            return (Criteria) this;
        }

        public Criteria andProductUrlNotIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl not in", values, "productUrl");
            return (Criteria) this;
        }

        public Criteria andProductUrlBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl between", value1, value2, "productUrl");
            return (Criteria) this;
        }

        public Criteria andProductUrlNotBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.ProductUrl not between", value1, value2, "productUrl");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("unionpaypopularmerchantproduct.`Status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.`Status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.`Status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`Status` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.`Status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`Status` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.`Status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`Status` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.`Status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`Status` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.`Status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`Status` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("unionpaypopularmerchantproduct.`Status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`Status` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("unionpaypopularmerchantproduct.`Status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("unionpaypopularmerchantproduct.`Status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("unionpaypopularmerchantproduct.`Status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("unionpaypopularmerchantproduct.`Status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("unionpaypopularmerchantproduct.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("unionpaypopularmerchantproduct.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("unionpaypopularmerchantproduct.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("unionpaypopularmerchantproduct.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("unionpaypopularmerchantproduct.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("unionpaypopularmerchantproduct.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("unionpaypopularmerchantproduct.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("unionpaypopularmerchantproduct.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("unionpaypopularmerchantproduct.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("unionpaypopularmerchantproduct.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("unionpaypopularmerchantproduct.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("unionpaypopularmerchantproduct.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("unionpaypopularmerchantproduct.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("unionpaypopularmerchantproduct.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("unionpaypopularmerchantproduct.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("unionpaypopularmerchantproduct.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("unionpaypopularmerchantproduct.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("unionpaypopularmerchantproduct.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("unionpaypopularmerchantproduct.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("unionpaypopularmerchantproduct.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("unionpaypopularmerchantproduct.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("unionpaypopularmerchantproduct.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("unionpaypopularmerchantproduct.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(UnionPayPopularMerchantProduct.Column column) {
            addCriterion(new StringBuilder("unionpaypopularmerchantproduct.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("unionpaypopularmerchantproduct.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private UnionPayPopularMerchantProductExample example;

        protected Criteria(UnionPayPopularMerchantProductExample example) {
            super();
            this.example = example;
        }

        public UnionPayPopularMerchantProductExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(UnionPayPopularMerchantProduct.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(UnionPayPopularMerchantProduct.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.union.pay.retailer.entity.UnionPayPopularMerchantProductExample example);
    }
}